# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月08日
"""
import pandas as pd


# def rise_in_price(x):
# 	return x + 3


path = '../数据文件/课件011/apply函数.xlsx'
data = pd.read_excel(path, index_col='序号')

data['加分'] = data['民族'].apply(lambda x:5 if x != '汉' else 0)
data['最终得分'] = data['总分'] + data['加分']
data['姓名字数'] = data['姓名'].apply(len)
print(data)
